

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">

<html>
<head>
<script type="text/javascript" src="helpman_topicinit.js"></script>

<title>Password Encryption [Enterprise Architect User Guide]</title>

<meta name="keywords" content="Enterprise Architect, Sparx Systems, UML, Password Encryption,Password Encryption Prior To Release 7.1 Of Enterprise Architect,Encrypt Password,Encrypt Password Prior To Release 7.1 Of Enterprise Architect">
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1" />
<meta http-equiv="Content-Style-Type" content="text/css" />

<link type="text/css" href="default.css" rel="stylesheet" />
<style type="text/css">
  A, A:Visited
  {
    color: #00F;
  }

  A:Active, A:Hover
  {
    color: #F00;
  }

  OL
  {
    margin: 5px 0 5px 48px;
  }

  UL
  {
    margin-bottom: 3px;
    margin-top: 0;
  }

  #nsr
  {
    background-color: #D4DFFF;
  }

  #nsr A
  {
    text-decoration: none;
  }

  #mainbody
  {
    padding: 8px;
  }

  .p_BodyText
  {
    padding: 5px 0;
  }
</style>



<style type="text/css" media="screen">
  BODY
  {
    background-color: #FFFFFF;
  }

  #nsr
  {
    padding: 6px 6px 0 6px;
    border-bottom: none;
    vertical-align: top;
    z-index: 2;
    visibility: visible;
    left: 0;
    top: 0;
    position: absolute;
  }

  #mainbody
  {
    left: 0;
    top: 0;
    margin: 0;
    position: absolute;
    padding: 10px;
    overflow: auto;
    height: 100%;
    z-index: 1;
    background-repeat: no-repeat;
    background-position: bottom right;
    background-attachment: fixed;
  }
</style>

<style type="text/css" media="print">
  #nsr
  {
    visibility: none;
  }

  #mainbody
  {
    overflow: visible;
  }
</style>
<script type="text/javascript" language="JavaScript" src="nonscroll.js"></script>

</head>
<body scroll="no">

<div id="page">



        <div id="content">
          <div id="content-inner">
          



  
          <div id="nsr">
            <table border="0" cellspacing="0" cellpadding="4" width="100%">
              <tr valign="top">
                <td align="left">
  


                  <p class="p_Heading1"><span class="f_Heading1">Password Encryption</span></p>



  
                </td>
                <td align="right">
                  <a href="introduction.htm" onmouseover="document.images.main.src='button_main_h.gif'" onmouseout="document.images.main.src='button_main.gif'">
                    <img name="main" src="button_main.gif" border=0 alt="Return to Introduction">
                  </a>&nbsp;
    
                  <a href="managelocks.htm" onmouseover="document.images.prev.src='button_prev_h.gif'" onmouseout="document.images.prev.src='button_prev.gif'">
                    <img name=prev src="button_prev.gif" border=0 alt="Previous page" />
                  </a>&nbsp;
    
    
    
                  <a href="change_password.htm" onmouseover="document.images.next.src='button_next_h.gif'" onmouseout="document.images.next.src='button_next.gif'">
                    <img name=next src="button_next.gif" border=0 alt="Next page" />
                  </a>
    
    
                </td>
              </tr>
            </table>
          </div>
          <div id="mainbody">
  


                <div style="text-align: left; text-indent: 0px; padding: 0px 0px 0px 0px; margin: 5px 0px 5px 13px;"><table cellspacing="0" cellpadding="2" border="0" style="border: none; border-spacing:0px;">
<tr style="text-align:left;vertical-align:bottom;">
<td valign="bottom" width="955" bgcolor="#efeff7" style="width:955px; background-color:#efeff7;"><p class="p_TiporNote" style="border-top: none; border-right: none; border-left: none;"><span class="f_TiporNote">Note:</span></p>
</td>
</tr>
<tr style="text-align:left;">
<td width="955" bgcolor="#f7f7ff" style="width:955px; background-color:#f7f7ff;"><p class="p_TiporNoteText"><span class="f_TiporNoteText">This topic is retained to support regression to releases of Enterprise Architect prior to version 7.1. For password encryption for all repositories at and beyond release 7.1, see the </span><span class="f_TiporNoteText" style="font-style: italic;"><a href="shortcuts_to__eap_files.htm">Save Model Copy or Shortcut</a></span><span class="f_TiporNoteText"> topic.</span></p>
</td>
</tr>
</table>
</div>
<p class="p_BodyText"><span class="f_BodyText">Users of SQL Server or Oracle repositories have the option of encrypting the password used to set up the connection between Enterprise Architect and the repository. The Enterprise Architect user does not have the real password, thereby preventing them from accessing the repository using other tools such as Query Analyzer or SQLPlus.</span></p>
<p class="p_BodyText"><span class="f_BodyText">Once security is enabled, the administrator must log on to access the dialog to create encrypted passwords. To encrypt a password, follow the steps below:</span></p>
<ol style="text-indent: 0px; margin-left: 48px; list-style-position: outside;">
<li value=1><span class="f_NumberedList">Select the </span><span class="f_MenuKeyField">Project | Security | Encrypt Password</span><span class="f_NumberedList"> menu option. The following dialog displays:</span><br>
<span class="f_NumberedList">&nbsp;</span><br>
<img src="passwordencrypt.png" width="271" height="133" border="0" alt="PasswordEncrypt"><span class="f_NumberedList"> </span><br>
<span class="f_NumberedList">&nbsp;</span></li>
<li value=2><span class="f_NumberedList">In the example above, the password </span><span class="f_MenuKeyField">password123</span><span class="f_NumberedList"> is used to access the repository.</span></li>
<li value=3><span class="f_NumberedList">To connect Enterprise Architect to the repository, the user enters the encrypted password prefixed with </span><span class="f_MenuKeyField">$$</span><span class="f_NumberedList">, so the encrypted password becomes </span><span class="f_MenuKeyField">$$qcvtyrsf435</span><span class="f_NumberedList">.</span></li>
</ol>
<p class="p_BodyText"><span class="f_BodyText">For more information relating to connecting to Oracle and SQL Server, see the </span><span class="f_BodyText" style="font-style: italic;"><a href="connecttoaoracle9idatarep.htm">Connect to Oracle Data Repository</a></span><span class="f_BodyText"> and </span><span class="f_BodyText" style="font-style: italic;"><a href="connecttosqlserver.htm">Connect to SQL Server Data Repository</a></span><span class="f_BodyText"> topics respectively.</span></p>
<div style="text-align: left; text-indent: 0px; padding: 0px 0px 0px 0px; margin: 5px 0px 5px 13px;"><table cellspacing="0" cellpadding="2" border="0" style="border: none; border-spacing:0px;">
<tr style="text-align:left;vertical-align:bottom;">
<td valign="bottom" width="955" bgcolor="#efeff7" style="width:955px; background-color:#efeff7;"><p class="p_TiporNote" style="border-top: none; border-right: none; border-left: none;"><span class="f_TiporNote">Notes:</span></p>
</td>
</tr>
<tr style="text-align:left;">
<td width="955" bgcolor="#f7f7ff" style="width:955px; background-color:#f7f7ff;"><ul style="text-indent: 0px; margin-left: 14px; list-style-position: outside;">
<li><span class="f_TiporNoteText">Do not use the </span><span class="f_MenuKeyField">Test Connection</span><span class="f_TiporNoteText"> button as it can cause an error with encrypted passwords.</span></li>
<li><span class="f_TiporNoteText">For SQL Server repositories, you must enter the </span><span class="f_TiporNoteText" style="font-style: italic;">Initial Catalog</span><span class="f_TiporNoteText"> details from the </span><span class="f_UIControl">All</span><span class="f_TiporNoteText"> tab of the </span><span class="f_UIControl">Data Link Properties</span><span class="f_TiporNoteText"> dialog.</span></li>
</ul>
</td>
</tr>
</table>
</div>
<p class="p_TextIndentedL2"><img src="datalinksql.png" width="356" height="429" border="0" alt="DataLinkSQL"></p>




            </div>
          </div>
        </div>



</div>


</body>
</html>
